#!/usr/bin/python2.7
#coding=utf8

class CreateTable(object):
    def generatetable(self,Config):
        from databaseOracle import SqlAlchemy
        self.session=SqlAlchemy().dbsession(Config)
        self.oraclesqlfilepath=Config.ORACLESQLFILEPATH
        obj=open(self.oraclesqlfilepath,'r')
        str=""
        for i in obj:
            #print(i)
            if not ";" in list(i):
                str=str+i
            else:
                str=str+i
                str=str[0:len(str)-2]
                print(str)
                self.session.execute(str)
                self.session.commit()
                str=""
                